

In [ ]:

    
import pandas as pd
import numpy as np

read from an Excel file

documentation: http://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_excel.html

you don't need to have MS-Excel on your computer



In [ ]:

    
file_name_string = 'C:/Users/Charles Kelly/Desktop/Exercise Files/02_07/Begin/EmployeesWithGrades.xlsx'
employees_df = pd.read_excel(file_name_string, 'Sheet1', index_col=None, na_values=['NA'])



In [ ]:

write to a comma separated value (.csv) file

documentation: http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.to_csv.html



In [ ]:

    
file_name_string_csv = 'C:/Users/Charles Kelly/Desktop/Exercise Files/02_07/Final/EmployeesWithGrades.csv'
employees_df.to_csv(file_name_string_csv )

Similar functions

Write to Excel

Read from .csv